package top.wardyan.wtask.service;

import java.sql.Timestamp;
import java.util.List;

import com.jfinal.plugin.activerecord.Record;
public interface IProcService {

	public void yp_tapd_clearworkhour(Timestamp date, String man);
	
	public void yp_tapd_workhour(Timestamp date, String man, String cust, Integer tapdid, Float hour, Boolean isFinish);
	

	public List<Record> yp_tapd_date(String man, Timestamp date);
	public String yp_tapd_mail(String man, Timestamp date);
	


	public List<Record> yp_query_feishu_week(String man, Timestamp date);

	public List<Record> yp_query_tapd_week(String man, Timestamp date);
	public List<Record> yp_query_tapd_month(String man, Timestamp date);
	public List<Record> yp_query_tapd_weektask(String man, Timestamp date);
	public List<Record> yp_query_tapd_weekemergency(String man, Timestamp date);
	
	

	public List<Record> yp_qry_weeksummary(Timestamp date);
	public List<Record> yp_listempls(Boolean all);
	
	public Record yp_qry_preimporttime();

	public List<Record> yp_task_qryweekalltask(Timestamp pBDate, Timestamp pEDate);
	public List<Record> yp_task_qryweekstatistics(Timestamp pBDate, Timestamp pEDate);
	
	public List<Record> yp_listgroups();

	public List<Record> yp_query_tapd_emergencys();
	

	public List<Record> yp_query_feishu_date(String man, Timestamp date);
	
	
	

	public List<Record> yp_query_progressing(String man, Timestamp date);
	public List<Record> yp_query_storyprogressing(String man, Timestamp date);
	public List<Record> yp_query_performance(String man, Timestamp date);
	
	
	

	public List<Record> yp_query_story(Timestamp begin, Timestamp end, String man, String text, String cust, String status);
	public List<Record> yp_query_story_count(Timestamp begin, Timestamp end, String man, String text, String cust, String status, Boolean isCust);
	

	public List<Record> yp_query_task(Timestamp begin, Timestamp end, String man, String text, String cust, String status);
	public List<Record> yp_query_task_count(Timestamp begin, Timestamp end, String man, String text, String cust, String status, Boolean isCust);
	

	public List<Record> yp_query_task_max(Timestamp begin, Timestamp end, String man, String text, String cust, String status);
	

	public List<Record> yp_sqlchecker_view(Timestamp begin, Timestamp end, Integer status, Integer tag, Integer sID);
	public List<Record> yp_sqlchecker_item_view(Integer mID, Integer datatype, Integer status, Integer level, String owner, String text, Integer tag);
	public List<Record> yp_sqlchecker_duplicate_view(Integer mID);

	public List<Record> yp_sqlchecker_allitem(Timestamp begin, Timestamp end, Integer datatype, Integer status, Integer level, String owner, String text, Integer tag);
	public List<Record> yp_sqlchecker_allduplicate(Timestamp begin, Timestamp end, String owner, String text, Integer tag);
	
	public void yp_sqlchecker_markbill(Integer pID, Integer status);
	public void yp_sqlchecker_markitem(Integer mID, Integer dID, Integer status);

	public List<Record> yp_sqlchecker_itemcost(Integer mID);
	public String yp_sqlchecker_report(Integer mID);

	public void yp_sqlchecker_markduplicate(Integer mID, Integer dID, Integer status);
	

	public List<Record> yp_listhoursbycust(Timestamp begin, Timestamp end, Integer datatype);
	
	public void yp_devreport_build(Integer id);
	public List<Record> yp_devreport_view(Timestamp begin, Timestamp end, Integer datatype, Integer pageNo, Integer pageSize);
	public List<Record> yp_devreport_hour_view(Integer mID);
	public List<Record> yp_devreport_team_view(Integer mID);
	public List<Record> yp_devreport_task_view(Integer mID);
	public List<Record> yp_devreport_emergency_view(Integer mID);
	public List<Record> yp_devreport_custhour_view(Integer mID, Integer datatype);
	public List<Record> yp_devreport_item_view(Integer mID);
	public List<Record> yp_devreport_date_view(Integer mID);
	public List<Record> yp_devreport_feishu_view(Integer mID);
	
	public Integer yp_getid(String tableName, String field, Integer cnt);
	public void yp_devreport_build_mark(Integer id);
	
	

	public List<Record> yp_query_feishu_list(Timestamp date, String man);
	
}
